To join multiple tables together to create a new feature, Oracle views are necessary. The view must have a primary key (disabled), an exposed geometry column, and be registered in the SDO Geometry metadata. To be able to update this type of view, triggers must be created.

In this example, one of the tables contains geometry and the other does not.